create database - Docs search results , p.4

50.1. Overview

database creation and are thereafter database-specific. A few catalogs are physically shared across all databases

19.5. Write Ahead Log

database will be thrown away and recreated, or for a read-only database clone which

pg_basebackup

database.) To create a backup of a local database where the tablespace in /opt/ts is relocated

DROP DATABASE

DATABASE statement in the SQL standard. See Also CREATE DATABASE Prev   Up   Next DROP CONVERSION

50.8. pg_authid

create databases rolcanlogin bool Role can log in. That is, this role can be given

50.72. pg_roles

create databases rolcanlogin bool   Role can log in. That is, this role can be given

PostgreSQL Client Applications

database createdb — create a new PostgreSQL database createlang — install a PostgreSQL procedural language createuser — define

50.81. pg_user

create databases usesuper bool User is a superuser userepl bool User can initiate streaming replication

1.4. Accessing a Database

Database Once you have created a database, you can access it by: Running the PostgreSQL

CREATE SERVER

database. Creating a server requires USAGE privilege on the foreign-data wrapper being used. Parameters

Chapter 66. BKI Backend Interface

creating a new database cluster. The input file used by initdb is created as part

50.76. pg_shadow

create databases usesuper bool   User is a superuser userepl bool   User can initiate streaming replication

50.36. pg_pltemplate

created in a particular database by a simple CREATE LANGUAGE command, with no need to specify

Chapter 22. Managing Databases

Databases Table of Contents 22.1. Overview 22.2. Creating a Database 22.3. Template Databases 22.4. Database

42.1. Overview

database users can be trusted to use this language; it does not give them unlimited authority. The other notable implementation restriction is that Tcl functions cannot be used to create